# import pandas as pd
# data = [[110, 120, 105], [95, 110, 108], [98, 80, 100], [112, 106, 97]]
# index = ['王蒙', '李珊', '赵胜', '刘文']
# columns = ['语文', '数学', '英语']
# df = pd.DataFrame(data, index, columns)
# print('保存的数据：\n', df)
# df.to_csv('Score.csv', encoding='GBK')
# df1 = pd.read_csv('Score.csv', index_col=0, encoding='GBK')
# print('导入的数据：\n', df1)
#
#
#

import pandas as pd
data = [[110, 120, 105], [95, 110, 108], [98, 80, 100], [112, 106, 97]]
index = ['王蒙', '李珊', '赵胜', '刘文']
columns = ['语文', '数学', '英语']
df = pd.DataFrame(data, index, columns)
print('保存到“scorel”工作表中的数据：\n', df)
writer = pd.ExcelWriter('Score.xlsx')
df.to_excel(writer, sheet_name='score1')
df.iloc[0] = [105, 118, 100]
print('保存到“score2”工作表中的数据：\n', df)
df.to_excel(writer, sheet_name='score2')
writer._save()
df1 = pd.read_excel('Score.xlsx', sheet_name=['score1', 'score2'], index_col=0)
print('导入的数据：\n', df1)
